Dataset info
| Number of variables | 47 |
|---|---|
| Number of observations | 224868 |
| Missing cells | 1761251 (16.7%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 92.3 MiB |
| Average record size in memory | 430.6 B |
Variables types
| Numeric | 17 |
|---|---|
| Categorical | 15 |
| Boolean | 2 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 13 |
| Unsupported | 0 |
Warnings
age_in_year has 4715 (2.1%) missing values | Missing |
avg_cash_deposit_90_days is highly skewed (γ1 = -94.07929124) | Skewed |
avg_cash_deposit_90_days has 200841 (89.3%) zeros | Zeros |
avg_last_10_days has 94127 (41.9%) zeros | Zeros |
avg_last_30_days is highly correlated with avg_last_10_days (ρ = 0.9983359321) | Rejected |
avg_last_90_days is highly correlated with avg_last_30_days (ρ = 0.9758176269) | Rejected |
avg_of_cash_wd_90_days is highly skewed (γ1 = 333.6228663) | Skewed |
avg_of_cash_wd_90_days has 203531 (90.5%) zeros | Zeros |
avg_of_dep_90_days is highly skewed (γ1 = -78.74361505) | Skewed |
avg_of_dep_90_days has 194845 (86.6%) zeros | Zeros |
avg_of_wd_90_days is highly skewed (γ1 = 79.56194195) | Skewed |
avg_of_wd_90_days has 199578 (88.8%) zeros | Zeros |
birthCountry has constant value "nan" | Rejected |
birthPlace has a high cardinality: 1001 distinct values | Warning |
birthPlace has 21842 (9.7%) missing values | Missing |
companyType has 110294 (49.0%) missing values | Missing |
creationDate only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
creationDate has a high cardinality: 7041 distinct values | Warning |
customerId is highly correlated with branchCode (ρ = 0.9550488158) | Rejected |
date_of_assessment has constant value "2019-01-24" | Rejected |
dateOfBirth has a high cardinality: 21458 distinct values | Warning |
dateOfBirth has 4715 (2.1%) missing values | Missing |
extraNationality has 223075 (99.2%) missing values | Missing |
fullaccount has a high cardinality: 220434 distinct values | Warning |
GENDER has 120511 (53.6%) missing values | Missing |
giinCode has 224856 (> 99.9%) missing values | Missing |
IsBlackListed has constant value "0" | Rejected |
lastUpdate has constant value "nan" | Rejected |
LEGAL_STA_CODE has 2616 (1.2%) missing values | Missing |
legal_Stat_desc has constant value "nan" | Rejected |
nationalityOriginal has a high cardinality: 68 distinct values | Warning |
nationalityOriginal has 3439 (1.5%) missing values | Missing |
number_of_cash_dep_90_days is highly skewed (γ1 = 90.82151456) | Skewed |
number_of_cash_dep_90_days has 200841 (89.3%) zeros | Zeros |
number_of_cash_wd_90_days has 203531 (90.5%) zeros | Zeros |
number_of_deposit_90_days is highly skewed (γ1 = 84.71319307) | Skewed |
number_of_deposit_90_days has 194594 (86.5%) zeros | Zeros |
number_of_wd_90_days is highly skewed (γ1 = 101.7646811) | Skewed |
number_of_wd_90_days has 199578 (88.8%) zeros | Zeros |
org_code has constant value "1" | Rejected |
profession has 145120 (64.5%) missing values | Missing |
rbaGradeAbrv is a recoding of rba_grade_desc | Rejected |
residentCountry has a high cardinality: 63 distinct values | Warning |
score_card_Desc has constant value "nan" | Rejected |
status has constant value "Active" | Rejected |
TYPE_OF_DEP is highly correlated with companyType (ρ = 1) | Rejected |
accountCurrency
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| JOD | |
|---|---|
| USD | 8478 |
| EUR | 1079 |
| Other values (17) | 654 |
| Value | Count | Frequency (%) | |
| JOD | 214657 | 95.5% | |
| USD | 8478 | 3.8% | |
| EUR | 1079 | 0.5% | |
| GBP | 254 | 0.1% | |
| AED | 93 | < 0.1% | |
| CAD | 81 | < 0.1% | |
| SAR | 60 | < 0.1% | |
| JPY | 41 | < 0.1% | |
| CHF | 40 | < 0.1% | |
| AUD | 37 | < 0.1% | |
| Other values (10) | 48 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
age_in_year
Numeric
| Distinct count | 107 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 2.1% |
| Missing (n) | 4715 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 41.31057492 |
|---|---|
| Minimum | 1 |
| Maximum | 119 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 31 |
| Median | 41 |
| Q3 | 52 |
| 95-th percentile | 69 |
| Maximum | 119 |
| Range | 118 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 16.00053637 |
|---|---|
| Coef of variation | 0.3873230137 |
| Kurtosis | 0.1113895923 |
| Mean | 41.31057492 |
| MAD | 12.6437128 |
| Skewness | 0.08737079223 |
| Sum | 9094647 |
| Variance | 256.0171643 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 36 | 6064 | 2.7% | |
| 38 | 6027 | 2.7% | |
| 40 | 5788 | 2.6% | |
| 39 | 5714 | 2.5% | |
| 35 | 5627 | 2.5% | |
| 46 | 5559 | 2.5% | |
| 41 | 5550 | 2.5% | |
| 37 | 5502 | 2.4% | |
| 34 | 5403 | 2.4% | |
| 42 | 5291 | 2.4% | |
| Other values (96) | 163628 | 72.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 103 | < 0.1% | |
| 2 | 595 | 0.3% | |
| 3 | 591 | 0.3% | |
| 4 | 874 | 0.4% | |
| 5 | 1210 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 119 | 38 | < 0.1% | |
| 114 | 2 | < 0.1% | |
| 108 | 1 | < 0.1% | |
| 104 | 5 | < 0.1% | |
| 102 | 1 | < 0.1% |
avg_cash_deposit_90_days
Numeric
| Distinct count | 5780 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -1113.434979 |
|---|---|
| Minimum | -5482044 |
| Maximum | 0 |
| Zeros (%) | 89.3% |
Quantile statistics
| Minimum | -5482044 |
|---|---|
| 5-th percentile | -850 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 5482044 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 30280.83845 |
|---|---|
| Coef of variation | -27.19587493 |
| Kurtosis | 11908.0351 |
| Mean | -1113.434979 |
| MAD | 2086.347044 |
| Skewness | -94.07929124 |
| Sum | -250375896.9 |
| Variance | 916929177 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 200841 | 89.3% | |
| -100 | 1041 | 0.5% | |
| -200 | 670 | 0.3% | |
| -500 | 621 | 0.3% | |
| -50 | 531 | 0.2% | |
| -1000 | 490 | 0.2% | |
| -150 | 464 | 0.2% | |
| -300 | 436 | 0.2% | |
| -400 | 342 | 0.2% | |
| -250 | 308 | 0.1% | |
| Other values (5770) | 19124 | 8.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -5482044 | 1 | < 0.1% | |
| -4641216.669 | 1 | < 0.1% | |
| -4004270.821 | 1 | < 0.1% | |
| -3533451.9 | 1 | < 0.1% | |
| -3165633 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0 | 200841 | 89.3% | |
| -0.001 | 2 | < 0.1% | |
| -0.02 | 1 | < 0.1% | |
| -0.05 | 3 | < 0.1% | |
| -0.1 | 4 | < 0.1% |
avg_last_10_days
Numeric
| Distinct count | 106519 |
|---|---|
| Unique (%) | 47.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7832.261245 |
|---|---|
| Minimum | -179100500.8 |
| Maximum | 153151400 |
| Zeros (%) | 41.9% |
Quantile statistics
| Minimum | -179100500.8 |
|---|---|
| 5-th percentile | -78270.104 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 691.4525 |
| 95-th percentile | 50305.604 |
| Maximum | 153151400 |
| Range | 332251900.8 |
| Interquartile range | 691.4525 |
Descriptive statistics
| Standard deviation | 1325115.661 |
|---|---|
| Coef of variation | 169.1868567 |
| Kurtosis | 4953.298876 |
| Mean | 7832.261245 |
| MAD | 90644.59831 |
| Skewness | -4.697407425 |
| Sum | 1761224922 |
| Variance | 1.755931514e+12 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 94127 | 41.9% | |
| 820 | 1207 | 0.5% | |
| 1640 | 375 | 0.2% | |
| -15 | 335 | 0.1% | |
| 1230 | 234 | 0.1% | |
| -6.98 | 168 | 0.1% | |
| 2460 | 137 | 0.1% | |
| 0.02 | 129 | 0.1% | |
| 82000 | 118 | 0.1% | |
| 4100 | 104 | < 0.1% | |
| Other values (106509) | 127934 | 56.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -179100500.8 | 1 | < 0.1% | |
| -143593689.9 | 1 | < 0.1% | |
| -113023279 | 1 | < 0.1% | |
| -110699754 | 1 | < 0.1% | |
| -82000000 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 153151400 | 1 | < 0.1% | |
| 130702934.6 | 1 | < 0.1% | |
| 118818000 | 1 | < 0.1% | |
| 84939437.7 | 1 | < 0.1% | |
| 82000000 | 2 | < 0.1% |
avg_last_30_days
Highly correlated
This variable is highly correlated with avg_last_10_days and should be ignored for analysis
| Correlation | 0.9983359321 |
|---|
avg_last_90_days
Highly correlated
This variable is highly correlated with avg_last_30_days and should be ignored for analysis
| Correlation | 0.9758176269 |
|---|
avg_of_cash_wd_90_days
Numeric
| Distinct count | 5348 |
|---|---|
| Unique (%) | 2.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 476.3851137 |
|---|---|
| Minimum | 0 |
| Maximum | 8394000 |
| Zeros (%) | 90.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 545.825 |
| Maximum | 8394000 |
| Range | 8394000 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 20281.0986 |
|---|---|
| Coef of variation | 42.57290587 |
| Kurtosis | 132724.9647 |
| Mean | 476.3851137 |
| MAD | 885.0465992 |
| Skewness | 333.6228663 |
| Sum | 107123767.8 |
| Variance | 411322960.6 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 203531 | 90.5% | |
| 100 | 712 | 0.3% | |
| 200 | 411 | 0.2% | |
| 500 | 342 | 0.2% | |
| 300 | 336 | 0.1% | |
| 50 | 286 | 0.1% | |
| 2000 | 280 | 0.1% | |
| 1000 | 278 | 0.1% | |
| 150 | 230 | 0.1% | |
| 3000 | 207 | 0.1% | |
| Other values (5338) | 18255 | 8.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 203531 | 90.5% | |
| 0.037 | 1 | < 0.1% | |
| 0.071 | 1 | < 0.1% | |
| 0.112 | 1 | < 0.1% | |
| 0.195 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8394000 | 1 | < 0.1% | |
| 2985000 | 1 | < 0.1% | |
| 1119817.655 | 1 | < 0.1% | |
| 1040173.287 | 1 | < 0.1% | |
| 1020664 | 1 | < 0.1% |
avg_of_dep_90_days
Numeric
| Distinct count | 11215 |
|---|---|
| Unique (%) | 5.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -3540.383152 |
|---|---|
| Minimum | -16543706.77 |
| Maximum | 586729.082 |
| Zeros (%) | 86.6% |
Quantile statistics
| Minimum | -16543706.77 |
|---|---|
| 5-th percentile | -2075 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 586729.082 |
| Range | 17130435.85 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 91516.02462 |
|---|---|
| Coef of variation | -25.84918657 |
| Kurtosis | 9162.069364 |
| Mean | -3540.383152 |
| MAD | 6746.342994 |
| Skewness | -78.74361505 |
| Sum | -796118878.5 |
| Variance | 8375182761 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 194845 | 86.6% | |
| -100 | 996 | 0.4% | |
| -200 | 655 | 0.3% | |
| -500 | 598 | 0.3% | |
| -1000 | 505 | 0.2% | |
| -50 | 504 | 0.2% | |
| -150 | 445 | 0.2% | |
| -300 | 428 | 0.2% | |
| -400 | 318 | 0.1% | |
| -250 | 298 | 0.1% | |
| Other values (11205) | 25276 | 11.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -16543706.77 | 1 | < 0.1% | |
| -12032495 | 1 | < 0.1% | |
| -10583486.54 | 1 | < 0.1% | |
| -8625015.044 | 1 | < 0.1% | |
| -8200000 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 586729.082 | 1 | < 0.1% | |
| 564593.312 | 1 | < 0.1% | |
| 560849.635 | 1 | < 0.1% | |
| 430291.9 | 1 | < 0.1% | |
| 373275 | 1 | < 0.1% |
avg_of_wd_90_days
Numeric
| Distinct count | 8674 |
|---|---|
| Unique (%) | 3.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2450.95292 |
|---|---|
| Minimum | 0 |
| Maximum | 9942530 |
| Zeros (%) | 88.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1100 |
| Maximum | 9942530 |
| Range | 9942530 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 58198.17628 |
|---|---|
| Coef of variation | 23.74512208 |
| Kurtosis | 9278.41859 |
| Mean | 2450.95292 |
| MAD | 4630.209449 |
| Skewness | 79.56194195 |
| Sum | 551140881.2 |
| Variance | 3387027723 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 199578 | 88.8% | |
| 100 | 710 | 0.3% | |
| 200 | 395 | 0.2% | |
| 300 | 346 | 0.2% | |
| 500 | 342 | 0.2% | |
| 1000 | 287 | 0.1% | |
| 50 | 278 | 0.1% | |
| 2000 | 267 | 0.1% | |
| 150 | 237 | 0.1% | |
| 400 | 199 | 0.1% | |
| Other values (8664) | 22229 | 9.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 199578 | 88.8% | |
| 0.037 | 1 | < 0.1% | |
| 0.071 | 1 | < 0.1% | |
| 0.112 | 1 | < 0.1% | |
| 0.2 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9942530 | 1 | < 0.1% | |
| 8420374.105 | 1 | < 0.1% | |
| 7815547.919 | 1 | < 0.1% | |
| 5232300 | 1 | < 0.1% | |
| 5046123.725 | 1 | < 0.1% |
birthCountry
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
birthPlace
Categorical
| Distinct count | 1001 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 9.7% |
| Missing (n) | 21842 |
| ???? | |
|---|---|
| ????? | |
| ?????? | |
| Other values (997) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| ???? | 76312 | 33.9% | |
| ????? | 38740 | 17.2% | |
| ?????? | 29904 | 13.3% | |
| ??????? | 19465 | 8.7% | |
| ???????? | 7690 | 3.4% | |
| ??? | 4507 | 2.0% | |
| ???? ????? | 1804 | 0.8% | |
| ??? ??? | 1725 | 0.8% | |
| ?????? ??????? | 1698 | 0.8% | |
| ??? ???? | 1409 | 0.6% | |
| Other values (990) | 19772 | 8.8% | |
| (Missing) | 21842 | 9.7% |
| Max length | 20 |
|---|---|
| Mean length | 5.474384973 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
branchCode
Numeric
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 448.4513226 |
|---|---|
| Minimum | 201 |
| Maximum | 805 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 201 |
|---|---|
| 5-th percentile | 202 |
| Q1 | 208 |
| Median | 401 |
| Q3 | 701 |
| 95-th percentile | 804 |
| Maximum | 805 |
| Range | 604 |
| Interquartile range | 493 |
Descriptive statistics
| Standard deviation | 228.1933076 |
|---|---|
| Coef of variation | 0.5088474404 |
| Kurtosis | -1.407185063 |
| Mean | 448.4513226 |
| MAD | 204.2056879 |
| Skewness | 0.3682172468 |
| Sum | 100842352 |
| Variance | 52072.18564 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 202 | 19684 | 8.8% | |
| 208 | 15974 | 7.1% | |
| 704 | 12882 | 5.7% | |
| 701 | 11332 | 5.0% | |
| 805 | 10428 | 4.6% | |
| 801 | 9262 | 4.1% | |
| 502 | 8870 | 3.9% | |
| 206 | 8598 | 3.8% | |
| 207 | 8458 | 3.8% | |
| 403 | 7673 | 3.4% | |
| Other values (20) | 111707 | 49.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 201 | 196 | 0.1% | |
| 202 | 19684 | 8.8% | |
| 203 | 5097 | 2.3% | |
| 204 | 5083 | 2.3% | |
| 205 | 6674 | 3.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 805 | 10428 | 4.6% | |
| 804 | 4525 | 2.0% | |
| 803 | 5494 | 2.4% | |
| 802 | 5782 | 2.6% | |
| 801 | 9262 | 4.1% |
companyType
Numeric
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 49.0% |
| Missing (n) | 110294 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 49.85757676 |
|---|---|
| Minimum | 1 |
| Maximum | 100 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 51 |
| Median | 51 |
| Q3 | 51 |
| 95-th percentile | 54 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 6.736114973 |
|---|---|
| Coef of variation | 0.1351071474 |
| Kurtosis | 30.90281903 |
| Mean | 49.85757676 |
| MAD | 2.847144843 |
| Skewness | -5.085653831 |
| Sum | 5712382 |
| Variance | 45.37524493 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 51 | 89314 | 39.7% | |
| 54 | 10041 | 4.5% | |
| 52 | 6150 | 2.7% | |
| 37 | 3830 | 1.7% | |
| 35 | 1151 | 0.5% | |
| 53 | 1011 | 0.4% | |
| 1 | 955 | 0.4% | |
| 36 | 819 | 0.4% | |
| 15 | 419 | 0.2% | |
| 14 | 251 | 0.1% | |
| Other values (23) | 633 | 0.3% | |
| (Missing) | 110294 | 49.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 955 | 0.4% | |
| 2 | 51 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 67 | < 0.1% | |
| 5 | 47 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 22 | < 0.1% | |
| 64 | 81 | < 0.1% | |
| 61 | 2 | < 0.1% | |
| 60 | 9 | < 0.1% | |
| 58 | 45 | < 0.1% |
creationDate
Categorical
| Distinct count | 7041 |
|---|---|
| Unique (%) | 3.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2013-11-20 | 1079 |
|---|---|
| 1994-05-18 | 951 |
| 2014-12-31 | 889 |
| Other values (7038) |
| Value | Count | Frequency (%) | |
| 2013-11-20 | 1079 | 0.5% | |
| 1994-05-18 | 951 | 0.4% | |
| 2014-12-31 | 889 | 0.4% | |
| 2010-07-28 | 714 | 0.3% | |
| 2016-08-04 | 600 | 0.3% | |
| 2015-01-27 | 459 | 0.2% | |
| 2010-05-31 | 447 | 0.2% | |
| 2015-05-11 | 389 | 0.2% | |
| 2013-06-02 | 383 | 0.2% | |
| 2013-10-08 | 371 | 0.2% | |
| Other values (7031) | 218586 | 97.2% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
CUS_CLASS
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.765231158 |
|---|---|
| Minimum | 0 |
| Maximum | 51 |
| Zeros (%) | 0.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 2 |
| 95-th percentile | 15 |
| Maximum | 51 |
| Range | 51 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.305014643 |
|---|---|
| Coef of variation | 1.143359986 |
| Kurtosis | 3.45730294 |
| Mean | 3.765231158 |
| MAD | 2.851769326 |
| Skewness | 2.206600277 |
| Sum | 846680 |
| Variance | 18.53315108 |
| Memory size | 3.4 MiB |
| Value | Count | Frequency (%) | |
| 2 | 158856 | 70.6% | |
| 15 | 28020 | 12.5% | |
| 4 | 20526 | 9.1% | |
| 1 | 10740 | 4.8% | |
| 3 | 4605 | 2.0% | |
| 0 | 1858 | 0.8% | |
| 6 | 228 | 0.1% | |
| 5 | 22 | < 0.1% | |
| 51 | 10 | < 0.1% | |
| 7 | 3 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1858 | 0.8% | |
| 1 | 10740 | 4.8% | |
| 2 | 158856 | 70.6% | |
| 3 | 4605 | 2.0% | |
| 4 | 20526 | 9.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51 | 10 | < 0.1% | |
| 15 | 28020 | 12.5% | |
| 7 | 3 | < 0.1% | |
| 6 | 228 | 0.1% | |
| 5 | 22 | < 0.1% |
customerId
Highly correlated
This variable is highly correlated with branchCode and should be ignored for analysis
| Correlation | 0.9550488158 |
|---|
customerType
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 2 | 25729 |
| Value | Count | Frequency (%) | |
| 1 | 199139 | 88.6% | |
| 2 | 25729 | 11.4% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
date_of_assessment
Constant
This variable is constant and should be ignored for analysis
| Constant value | 2019-01-24 |
|---|
dateOfBirth
Categorical
| Distinct count | 21458 |
|---|---|
| Unique (%) | 9.5% |
| Missing (%) | 2.1% |
| Missing (n) | 4715 |
| 1992-07-22 | 1035 |
|---|---|
| 1994-05-16 | 944 |
| 1996-06-15 | 727 |
| Other values (21454) | |
| (Missing) | 4715 |
| Value | Count | Frequency (%) | |
| 1992-07-22 | 1035 | 0.5% | |
| 1994-05-16 | 944 | 0.4% | |
| 1996-06-15 | 727 | 0.3% | |
| 1973-06-13 | 710 | 0.3% | |
| 1946-01-01 | 541 | 0.2% | |
| 1944-01-01 | 530 | 0.2% | |
| 1943-01-01 | 528 | 0.2% | |
| 1947-01-01 | 502 | 0.2% | |
| 1948-01-01 | 469 | 0.2% | |
| 1949-01-01 | 451 | 0.2% | |
| Other values (21447) | 213716 | 95.0% | |
| (Missing) | 4715 | 2.1% |
| Max length | 10 |
|---|---|
| Mean length | 9.853225003 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
ECO_SEC
Numeric
| Distinct count | 206 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 89.38863244 |
|---|---|
| Minimum | 0 |
| Maximum | 392 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 46 |
| Q1 | 90 |
| Median | 90 |
| Q3 | 90 |
| 95-th percentile | 90 |
| Maximum | 392 |
| Range | 392 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 29.4068492 |
|---|---|
| Coef of variation | 0.3289775041 |
| Kurtosis | 36.24076031 |
| Mean | 89.38863244 |
| MAD | 7.905656937 |
| Skewness | 4.685560299 |
| Sum | 20100643 |
| Variance | 864.7627799 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 90 | 199270 | 88.6% | |
| 99 | 1718 | 0.8% | |
| 51 | 1583 | 0.7% | |
| 42 | 1527 | 0.7% | |
| 40 | 1492 | 0.7% | |
| 43 | 1135 | 0.5% | |
| 30 | 1115 | 0.5% | |
| 289 | 1109 | 0.5% | |
| 17 | 1055 | 0.5% | |
| 62 | 983 | 0.4% | |
| Other values (196) | 13881 | 6.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 237 | 0.1% | |
| 1 | 288 | 0.1% | |
| 2 | 481 | 0.2% | |
| 5 | 98 | < 0.1% | |
| 6 | 45 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 392 | 2 | < 0.1% | |
| 386 | 2 | < 0.1% | |
| 385 | 4 | < 0.1% | |
| 384 | 29 | < 0.1% | |
| 383 | 7 | < 0.1% |
extraNationality
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.2% |
| Missing (n) | 223075 |
| US | 1028 |
|---|---|
| XK | 435 |
| CA | 45 |
| Other values (32) | 285 |
| (Missing) |
| Value | Count | Frequency (%) | |
| US | 1028 | 0.5% | |
| XK | 435 | 0.2% | |
| CA | 45 | < 0.1% | |
| GB | 42 | < 0.1% | |
| JO | 34 | < 0.1% | |
| CO | 20 | < 0.1% | |
| AU | 17 | < 0.1% | |
| FR | 15 | < 0.1% | |
| BA | 15 | < 0.1% | |
| IQ | 14 | < 0.1% | |
| Other values (25) | 128 | 0.1% | |
| (Missing) | 223075 | 99.2% |
| Max length | 3 |
|---|---|
| Mean length | 2.992026433 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
fullaccount
Categorical
| Distinct count | 220434 |
|---|---|
| Unique (%) | 98.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 020902507770010010000 | 26 |
|---|---|
| 020301298000011306000 | 23 |
| 020301298000011930000 | 23 |
| Other values (220431) |
| Value | Count | Frequency (%) | |
| 020902507770010010000 | 26 | < 0.1% | |
| 020301298000011306000 | 23 | < 0.1% | |
| 020301298000011930000 | 23 | < 0.1% | |
| 020301298000011930001 | 23 | < 0.1% | |
| 020301298000012969000 | 23 | < 0.1% | |
| 020301298000012957000 | 23 | < 0.1% | |
| 020301298000011316000 | 23 | < 0.1% | |
| 020200616090010010000 | 20 | < 0.1% | |
| 020902501410010010000 | 19 | < 0.1% | |
| 080102501410010010000 | 19 | < 0.1% | |
| Other values (220424) | 224646 | 99.9% |
| Max length | 21 |
|---|---|
| Mean length | 21 |
| Min length | 21 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
GENDER
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 53.6% |
| Missing (n) | 120511 |
| 1 | |
|---|---|
| 2 | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 78166 | 34.8% | |
| 2 | 26191 | 11.6% | |
| (Missing) | 120511 | 53.6% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
giinCode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 224856 |
| ZLVK2E.99999.SL.400 | 12 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| ZLVK2E.99999.SL.400 | 12 | < 0.1% | |
| (Missing) | 224856 | > 99.9% |
| Max length | 19 |
|---|---|
| Mean length | 3.000853834 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
IsBlackListed
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
jointAccount
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4869 |
| Value | Count | Frequency (%) | |
| 0 | 219999 | 97.8% | |
| 1 | 4869 | 2.2% |
lastUpdate
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
ledgerCode
Numeric
| Distinct count | 227 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1059.328757 |
|---|---|
| Minimum | 10 |
| Maximum | 8700 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 20 |
| Median | 1302 |
| Q3 | 1396 |
| 95-th percentile | 3305 |
| Maximum | 8700 |
| Range | 8690 |
| Interquartile range | 1376 |
Descriptive statistics
| Standard deviation | 1280.875258 |
|---|---|
| Coef of variation | 1.20913857 |
| Kurtosis | 1.715218149 |
| Mean | 1059.328757 |
| MAD | 1016.407641 |
| Skewness | 1.372232762 |
| Sum | 238209139 |
| Variance | 1640641.428 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 10 | 49473 | 22.0% | |
| 60 | 45284 | 20.1% | |
| 1355 | 16839 | 7.5% | |
| 1389 | 9480 | 4.2% | |
| 20 | 9218 | 4.1% | |
| 1318 | 8565 | 3.8% | |
| 1344 | 7453 | 3.3% | |
| 1406 | 7140 | 3.2% | |
| 1924 | 7133 | 3.2% | |
| 2951 | 5783 | 2.6% | |
| Other values (217) | 58500 | 26.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 10 | 49473 | 22.0% | |
| 13 | 2 | < 0.1% | |
| 20 | 9218 | 4.1% | |
| 30 | 68 | < 0.1% | |
| 42 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8700 | 1 | < 0.1% | |
| 8245 | 5 | < 0.1% | |
| 8212 | 2 | < 0.1% | |
| 8208 | 3 | < 0.1% | |
| 5817 | 5 | < 0.1% |
LEGAL_STA_CODE
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 1.2% |
| Missing (n) | 2616 |
| 1 | |
|---|---|
| 2 | 18828 |
| 3 | 10536 |
| (Missing) | 2616 |
| Value | Count | Frequency (%) | |
| 1 | 191848 | 85.3% | |
| 2 | 18828 | 8.4% | |
| 3 | 10536 | 4.7% | |
| 4 | 1040 | 0.5% | |
| (Missing) | 2616 | 1.2% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
legal_Stat_desc
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
nationalityOriginal
Categorical
| Distinct count | 68 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 1.5% |
| Missing (n) | 3439 |
| JO | |
|---|---|
| IQ | 3206 |
| EG | 1349 |
| Other values (64) | 3733 |
| (Missing) | 3439 |
| Value | Count | Frequency (%) | |
| JO | 213141 | 94.8% | |
| IQ | 3206 | 1.4% | |
| EG | 1349 | 0.6% | |
| SY | 1215 | 0.5% | |
| LY | 433 | 0.2% | |
| US | 243 | 0.1% | |
| PK | 223 | 0.1% | |
| SA | 178 | 0.1% | |
| CA | 160 | 0.1% | |
| PH | 134 | 0.1% | |
| Other values (57) | 1147 | 0.5% | |
| (Missing) | 3439 | 1.5% |
| Max length | 3 |
|---|---|
| Mean length | 2.015293417 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
number_of_cash_dep_90_days
Numeric
| Distinct count | 151 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.491421634 |
|---|---|
| Minimum | 0 |
| Maximum | 1267 |
| Zeros (%) | 89.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 1267 |
| Range | 1267 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 5.335239771 |
|---|---|
| Coef of variation | 10.85674582 |
| Kurtosis | 16551.90974 |
| Mean | 0.491421634 |
| MAD | 0.8778271021 |
| Skewness | 90.82151456 |
| Sum | 110505 |
| Variance | 28.46478342 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 200841 | 89.3% | |
| 1 | 10433 | 4.6% | |
| 2 | 4411 | 2.0% | |
| 3 | 3088 | 1.4% | |
| 4 | 1757 | 0.8% | |
| 5 | 922 | 0.4% | |
| 6 | 579 | 0.3% | |
| 7 | 377 | 0.2% | |
| 8 | 311 | 0.1% | |
| 9 | 247 | 0.1% | |
| Other values (141) | 1902 | 0.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 200841 | 89.3% | |
| 1 | 10433 | 4.6% | |
| 2 | 4411 | 2.0% | |
| 3 | 3088 | 1.4% | |
| 4 | 1757 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1267 | 1 | < 0.1% | |
| 655 | 1 | < 0.1% | |
| 583 | 1 | < 0.1% | |
| 396 | 1 | < 0.1% | |
| 386 | 1 | < 0.1% |
number_of_cash_wd_90_days
Numeric
| Distinct count | 45 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2543047477 |
|---|---|
| Minimum | 0 |
| Maximum | 78 |
| Zeros (%) | 90.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 78 |
| Range | 78 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.175585697 |
|---|---|
| Coef of variation | 4.622743804 |
| Kurtosis | 384.2512853 |
| Mean | 0.2543047477 |
| MAD | 0.4603491791 |
| Skewness | 12.87228251 |
| Sum | 57185 |
| Variance | 1.38200173 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 203531 | 90.5% | |
| 1 | 9376 | 4.2% | |
| 2 | 3693 | 1.6% | |
| 3 | 3163 | 1.4% | |
| 4 | 2283 | 1.0% | |
| 5 | 913 | 0.4% | |
| 6 | 561 | 0.2% | |
| 7 | 492 | 0.2% | |
| 8 | 256 | 0.1% | |
| 9 | 141 | 0.1% | |
| Other values (35) | 459 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 203531 | 90.5% | |
| 1 | 9376 | 4.2% | |
| 2 | 3693 | 1.6% | |
| 3 | 3163 | 1.4% | |
| 4 | 2283 | 1.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 78 | 1 | < 0.1% | |
| 65 | 1 | < 0.1% | |
| 58 | 2 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 55 | 1 | < 0.1% |
number_of_deposit_90_days
Numeric
| Distinct count | 293 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.13143711 |
|---|---|
| Minimum | 0 |
| Maximum | 3292 |
| Zeros (%) | 86.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 3292 |
| Range | 3292 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 19.71373929 |
|---|---|
| Coef of variation | 17.42362798 |
| Kurtosis | 10076.0644 |
| Mean | 1.13143711 |
| MAD | 1.97102631 |
| Skewness | 84.71319307 |
| Sum | 254424 |
| Variance | 388.6315166 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 194594 | 86.5% | |
| 1 | 10952 | 4.9% | |
| 2 | 5039 | 2.2% | |
| 3 | 4298 | 1.9% | |
| 4 | 2774 | 1.2% | |
| 5 | 1416 | 0.6% | |
| 6 | 917 | 0.4% | |
| 7 | 617 | 0.3% | |
| 8 | 411 | 0.2% | |
| 9 | 375 | 0.2% | |
| Other values (283) | 3475 | 1.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 194594 | 86.5% | |
| 1 | 10952 | 4.9% | |
| 2 | 5039 | 2.2% | |
| 3 | 4298 | 1.9% | |
| 4 | 2774 | 1.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3292 | 1 | < 0.1% | |
| 2941 | 1 | < 0.1% | |
| 2533 | 1 | < 0.1% | |
| 2185 | 1 | < 0.1% | |
| 2061 | 1 | < 0.1% |
number_of_wd_90_days
Numeric
| Distinct count | 259 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.8685184197 |
|---|---|
| Minimum | 0 |
| Maximum | 2858 |
| Zeros (%) | 88.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 2858 |
| Range | 2858 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 12.37399226 |
|---|---|
| Coef of variation | 14.24724218 |
| Kurtosis | 18163.54561 |
| Mean | 0.8685184197 |
| MAD | 1.541679289 |
| Skewness | 101.7646811 |
| Sum | 195302 |
| Variance | 153.1156845 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 0 | 199578 | 88.8% | |
| 1 | 9224 | 4.1% | |
| 2 | 3837 | 1.7% | |
| 3 | 3455 | 1.5% | |
| 4 | 2537 | 1.1% | |
| 5 | 1122 | 0.5% | |
| 6 | 774 | 0.3% | |
| 7 | 657 | 0.3% | |
| 8 | 425 | 0.2% | |
| 9 | 280 | 0.1% | |
| Other values (249) | 2979 | 1.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 199578 | 88.8% | |
| 1 | 9224 | 4.1% | |
| 2 | 3837 | 1.7% | |
| 3 | 3455 | 1.5% | |
| 4 | 2537 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2858 | 1 | < 0.1% | |
| 2135 | 1 | < 0.1% | |
| 1398 | 1 | < 0.1% | |
| 1043 | 1 | < 0.1% | |
| 882 | 1 | < 0.1% |
onboarding
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 5077 |
| Value | Count | Frequency (%) | |
| N | 219791 | 97.7% | |
| Y | 5077 | 2.3% |
org_code
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
profession
Numeric
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 64.5% |
| Missing (n) | 145120 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 18.30948739 |
|---|---|
| Minimum | 1 |
| Maximum | 39 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 20 |
| Median | 20 |
| Q3 | 21 |
| 95-th percentile | 25 |
| Maximum | 39 |
| Range | 38 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 6.586480584 |
|---|---|
| Coef of variation | 0.3597304744 |
| Kurtosis | 0.9163871085 |
| Mean | 18.30948739 |
| MAD | 4.875689433 |
| Skewness | -1.329862885 |
| Sum | 1460145 |
| Variance | 43.38172648 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 20 | 30334 | 13.5% | |
| 21 | 13155 | 5.9% | |
| 25 | 6987 | 3.1% | |
| 23 | 4571 | 2.0% | |
| 10 | 4100 | 1.8% | |
| 3 | 3468 | 1.5% | |
| 17 | 2919 | 1.3% | |
| 2 | 2078 | 0.9% | |
| 26 | 1708 | 0.8% | |
| 15 | 1620 | 0.7% | |
| Other values (22) | 8808 | 3.9% | |
| (Missing) | 145120 | 64.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1278 | 0.6% | |
| 2 | 2078 | 0.9% | |
| 3 | 3468 | 1.5% | |
| 4 | 674 | 0.3% | |
| 5 | 658 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 39 | 2 | < 0.1% | |
| 33 | 17 | < 0.1% | |
| 31 | 3 | < 0.1% | |
| 29 | 967 | 0.4% | |
| 28 | 125 | 0.1% |
rba_grade_desc
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Low | |
|---|---|
| Medium | |
| High | 89 |
| Value | Count | Frequency (%) | |
| Low | 159680 | 71.0% | |
| Medium | 65099 | 28.9% | |
| High | 89 | < 0.1% |
| Max length | 6 |
|---|---|
| Mean length | 3.868891972 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
rbaGradeAbrv
Recoded
This variable is a recoding of rba_grade_desc and should be ignored for analysis
rbaValue
Numeric
| Distinct count | 692 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17.62419353 |
|---|---|
| Minimum | 4.08 |
| Maximum | 100 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4.08 |
|---|---|
| 5-th percentile | 5.33 |
| Q1 | 13.33 |
| Median | 16.53 |
| Q3 | 21.33 |
| 95-th percentile | 32.29 |
| Maximum | 100 |
| Range | 95.92 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 8.368345407 |
|---|---|
| Coef of variation | 0.474821466 |
| Kurtosis | 4.01123456 |
| Mean | 17.62419353 |
| MAD | 5.958462163 |
| Skewness | 1.379485406 |
| Sum | 3963117.15 |
| Variance | 70.02920484 |
| Memory size | 13.4 MiB |
| Value | Count | Frequency (%) | |
| 16.53 | 29341 | 13.0% | |
| 14.53 | 25608 | 11.4% | |
| 5.33 | 10844 | 4.8% | |
| 7.33 | 9787 | 4.4% | |
| 15.28 | 7648 | 3.4% | |
| 5.5 | 6783 | 3.0% | |
| 13.28 | 6283 | 2.8% | |
| 26.13 | 5865 | 2.6% | |
| 10.5 | 5544 | 2.5% | |
| 21.33 | 4885 | 2.2% | |
| Other values (682) | 112280 | 49.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4.08 | 719 | 0.3% | |
| 5.33 | 10844 | 4.8% | |
| 5.5 | 6783 | 3.0% | |
| 5.68 | 12 | < 0.1% | |
| 5.83 | 24 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 1 | < 0.1% | |
| 82.5 | 2 | < 0.1% | |
| 70 | 2 | < 0.1% | |
| 67.5 | 2 | < 0.1% | |
| 65.6 | 82 | < 0.1% |
residentCountry
Categorical
| Distinct count | 63 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.3% |
| Missing (n) | 596 |
| JO | |
|---|---|
| OM | 985 |
| IQ | 981 |
| Other values (59) | 3053 |
| Value | Count | Frequency (%) | |
| JO | 219253 | 97.5% | |
| OM | 985 | 0.4% | |
| IQ | 981 | 0.4% | |
| SA | 657 | 0.3% | |
| US | 358 | 0.2% | |
| AE | 313 | 0.1% | |
| SY | 264 | 0.1% | |
| LY | 207 | 0.1% | |
| QA | 173 | 0.1% | |
| KW | 150 | 0.1% | |
| Other values (52) | 931 | 0.4% | |
| (Missing) | 596 | 0.3% |
| Max length | 3 |
|---|---|
| Mean length | 2.002650444 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
residentStatus
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 2 | 4772 |
| Value | Count | Frequency (%) | |
| 1 | 220096 | 97.9% | |
| 2 | 4772 | 2.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
score_card
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| I-Existing | |
|---|---|
| E-Existing | 25114 |
| I-New | 20649 |
| Value | Count | Frequency (%) | |
| I-Existing | 178495 | 79.4% | |
| E-Existing | 25114 | 11.2% | |
| I-New | 20649 | 9.2% | |
| E-NEW | 610 | 0.3% |
| Max length | 10 |
|---|---|
| Mean length | 9.527300461 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
score_card_Desc
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
status
Constant
This variable is constant and should be ignored for analysis
| Constant value | Active |
|---|
TYPE_OF_DEP
Highly correlated
This variable is highly correlated with companyType and should be ignored for analysis
| Correlation | 1 |
|---|
First rows
| accountCurrency | age_in_year | avg_cash_deposit_90_days | avg_last_10_days | avg_last_30_days | avg_last_90_days | avg_of_cash_wd_90_days | avg_of_dep_90_days | avg_of_wd_90_days | birthCountry | birthPlace | branchCode | companyType | creationDate | CUS_CLASS | customerId | customerType | date_of_assessment | dateOfBirth | ECO_SEC | extraNationality | fullaccount | GENDER | giinCode | IsBlackListed | jointAccount | lastUpdate | ledgerCode | LEGAL_STA_CODE | legal_Stat_desc | nationalityOriginal | number_of_cash_dep_90_days | number_of_cash_wd_90_days | number_of_deposit_90_days | number_of_wd_90_days | onboarding | org_code | profession | rba_grade_desc | rbaGradeAbrv | rbaValue | residentCountry | residentStatus | score_card | score_card_Desc | status | TYPE_OF_DEP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | JOD | NaN | 0.0 | 8610000.00 | 2170000.00 | 23333.33 | 0.0 | 0.0 | 0.0 | NaN | NaN | 201 | 35.0 | 2015-04-05 | 4 | 20100400550000072 | 2 | 2019-01-24 | NaN | 46 | NaN | 020100400550015817000 | NaN | NaN | 0 | 0 | NaN | 5817 | 2.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Low | L | 13.20 | JO | 1 | E-Existing | NaN | Active | 35 |
| 1 | JOD | 30.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011330000 | 2.0 | NaN | 0 | 0 | NaN | 1330 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 2 | JOD | 30.0 | 0.0 | -137562.72 | -34672.52 | -369.81 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011389002 | 2.0 | NaN | 0 | 0 | NaN | 1389 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 3 | JOD | 30.0 | -550.0 | 2079.79 | 526.87 | 6.68 | 50.0 | -550.0 | 50.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860010060000 | 2.0 | NaN | 0 | 0 | NaN | 60 | 1.0 | NaN | JO | 4 | 1 | 4 | 1 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 4 | JOD | 30.0 | -540.0 | 444.00 | 120.50 | 0.95 | 56.0 | -540.0 | 56.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860010010000 | 2.0 | NaN | 0 | 0 | NaN | 10 | 1.0 | NaN | JO | 4 | 1 | 4 | 1 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 5 | JOD | 30.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011355003 | 2.0 | NaN | 0 | 0 | NaN | 1355 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 6 | JOD | 30.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011355002 | 2.0 | NaN | 0 | 0 | NaN | 1355 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 7 | JOD | 30.0 | 0.0 | 24.60 | 6.20 | 0.07 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860013284000 | 2.0 | NaN | 0 | 0 | NaN | 3284 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 8 | JOD | 30.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011389000 | 2.0 | NaN | 0 | 0 | NaN | 1389 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
| 9 | JOD | 30.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 202 | NaN | 2013-09-17 | 2 | 20200207860000638 | 1 | 2019-01-24 | 1989-06-30 | 90 | NaN | 020200207860011389001 | 2.0 | NaN | 0 | 0 | NaN | 1389 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 27.0 | Low | L | 16.93 | JO | 1 | I-Existing | NaN | Active | 23 |
Last rows
| accountCurrency | age_in_year | avg_cash_deposit_90_days | avg_last_10_days | avg_last_30_days | avg_last_90_days | avg_of_cash_wd_90_days | avg_of_dep_90_days | avg_of_wd_90_days | birthCountry | birthPlace | branchCode | companyType | creationDate | CUS_CLASS | customerId | customerType | date_of_assessment | dateOfBirth | ECO_SEC | extraNationality | fullaccount | GENDER | giinCode | IsBlackListed | jointAccount | lastUpdate | ledgerCode | LEGAL_STA_CODE | legal_Stat_desc | nationalityOriginal | number_of_cash_dep_90_days | number_of_cash_wd_90_days | number_of_deposit_90_days | number_of_wd_90_days | onboarding | org_code | profession | rba_grade_desc | rbaGradeAbrv | rbaValue | residentCountry | residentStatus | score_card | score_card_Desc | status | TYPE_OF_DEP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 224858 | JOD | 29.0 | 0.0 | -223.53 | -63.85 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ?????? | 403 | NaN | 2018-05-15 | 2 | 40300894470009989 | 1 | 2019-01-24 | 1990-05-15 | 90 | NaN | 040300894470011406010 | 1.0 | NaN | 0 | 0 | NaN | 1406 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 25.0 | Low | L | 10.50 | JO | 1 | I-New | NaN | Active | 20 |
| 224859 | USD | 24.0 | -3000.0 | 1870.18 | 616.17 | 0.01 | 0.0 | -3000.0 | 0.0 | NaN | ?????? | 404 | NaN | 2018-10-17 | 1 | 40400976350003848 | 1 | 2019-01-24 | 1995-08-10 | 90 | NaN | 040400976350020060000 | 1.0 | NaN | 0 | 0 | NaN | 60 | 1.0 | NaN | EG | 1 | 0 | 1 | 0 | Y | 1 | 22.0 | Medium | M | 25.00 | JO | 1 | I-New | NaN | Active | 20 |
| 224860 | JOD | 24.0 | -500.0 | 13760.54 | 3489.72 | 39.75 | 0.0 | -500.0 | 0.0 | NaN | ????? | 701 | NaN | 2016-02-25 | 15 | 70100469970003615 | 1 | 2019-01-24 | 1995-02-25 | 90 | NaN | 070100469970010060000 | NaN | NaN | 0 | 0 | NaN | 60 | 1.0 | NaN | JO | 3 | 0 | 3 | 0 | N | 1 | NaN | Low | L | 19.73 | JO | 1 | I-Existing | NaN | Active | 20 |
| 224861 | JOD | 49.0 | 0.0 | -171193.36 | -43177.59 | -462.20 | 0.0 | 0.0 | 0.0 | NaN | ???? | 208 | 51.0 | 2018-04-24 | 2 | 20800885450011871 | 1 | 2019-01-24 | 1970-06-11 | 90 | NaN | 020800885450011389000 | 1.0 | NaN | 0 | 0 | NaN | 1389 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | 20.0 | Low | L | 10.50 | JO | 1 | I-New | NaN | Active | 51 |
| 224862 | JOD | 32.0 | 0.0 | 73.00 | 22.80 | 0.10 | 0.0 | 0.0 | 0.0 | NaN | ??????? | 502 | 51.0 | 2015-02-26 | 15 | 50200388440002560 | 1 | 2019-01-24 | 1987-11-20 | 90 | NaN | 050200388440010010000 | 2.0 | NaN | 0 | 0 | NaN | 10 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Medium | M | 26.13 | JO | 1 | I-Existing | NaN | Active | 51 |
| 224863 | JOD | 66.0 | 0.0 | 82249.30 | 20728.80 | 222.94 | 0.0 | 0.0 | 0.0 | NaN | ???? | 404 | NaN | 2017-10-22 | 2 | 40400811920003507 | 1 | 2019-01-24 | 1953-06-07 | 90 | NaN | 040400811920010020000 | 1.0 | NaN | 0 | 0 | NaN | 20 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Low | L | 16.53 | JO | 1 | I-Existing | NaN | Active | 20 |
| 224864 | JOD | 13.0 | 0.0 | 111388.80 | 28073.60 | 301.87 | 0.0 | 0.0 | 0.0 | NaN | NaN | 202 | 35.0 | 2004-07-27 | 4 | 20200577640010547 | 2 | 2019-01-24 | 2006-09-12 | 42 | NaN | 020200577640015300042 | NaN | NaN | 0 | 0 | NaN | 5300 | 3.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Medium | M | 57.60 | JO | 1 | E-Existing | NaN | Active | 35 |
| 224865 | JOD | 41.0 | 0.0 | 6597.29 | 1662.73 | 17.88 | 0.0 | 0.0 | 0.0 | NaN | ????????/??????? | 502 | 51.0 | 2000-08-23 | 2 | 50220271300005255 | 1 | 2019-01-24 | 1978-06-01 | 90 | NaN | 050220271300012980002 | NaN | NaN | 0 | 0 | NaN | 2980 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Low | L | 14.53 | JO | 1 | I-Existing | NaN | Active | 51 |
| 224866 | JOD | 70.0 | 0.0 | -110.01 | -18.34 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ???? | 704 | NaN | 2008-01-16 | 2 | 70424500690004664 | 1 | 2019-01-24 | 1949-01-01 | 90 | NaN | 070424500690011396000 | 2.0 | NaN | 0 | 0 | NaN | 1396 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Medium | M | 24.53 | JO | 1 | I-Existing | NaN | Active | 20 |
| 224867 | JOD | 32.0 | 0.0 | 0.00 | 0.00 | 0.00 | 0.0 | 0.0 | 0.0 | NaN | ??????/????? | 209 | 51.0 | 2015-10-14 | 15 | 20900444790003021 | 1 | 2019-01-24 | 1987-07-28 | 90 | NaN | 020900444790011396000 | NaN | NaN | 0 | 0 | NaN | 1396 | 1.0 | NaN | JO | 0 | 0 | 0 | 0 | N | 1 | NaN | Medium | M | 22.88 | JO | 1 | I-Existing | NaN | Active | 51 |